package com.zz.parkingsystem.mapper;

import com.zz.parkingsystem.entity.Refund;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.Date;

/**
 * @author zz
 * @description 针对表【t_refund(退款表)】的数据库操作Mapper
 * @createDate 2022-09-02 16:52:07
 * @Entity com.zz.parkingsystem.entity.Refund
 */
@Repository
@Mapper
public interface RefundMapper {
    //所有退款的数量
    int selRefundSum();

    //总退款金额
    double selMoneySum();

    //所有退款的数量根据时间查
    int SumNumberBytime(Date ref_time);

    //按照每天日期显示每日退款金额
    double SumMoneyBytime(Date ref_time);

    int deleteByPrimaryKey(Long id);

    int insert(Refund record);

    int insertSelective(Refund record);

    Refund selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Refund record);

    int updateByPrimaryKey(Refund record);

}
